How to: Use the SUM function.
Solution:
Select the cell where the result of the SUM function should be displayed. Enter =SUM(<cell range>), where <cell range> is a range of cells.
1) Select the cell where the result of the SUM function is to be displayed. (The cell is highlighted.)
2) Type an equal sign and the SUM command:
=SUM()
3) Do one of the following to specify the cell range that contains the values to be totaled:
a) Type the range reference within the parentheses of the SUM command.
EXAMPLE: =SUM(D5:D10)
NOTE: For multiple ranges, separate each range with a comma. No spaces should exist in the formula.
b) Select the desired range with the mouse.
NOTE: Be sure that the range is included in parentheses. For multiple ranges, separate each range with a comma.
4) Press ENTER. (Excel displays the total of the values contained in the specified range in the selected cell.)
